Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
893 questions
1 answer
track_commit_timestamp server parameter in Azure Database for PostgreSQL flexible server
I see that track_commit_timestamp server parameter is disabled by default in Azure Database for PostgreSQL flexible server, I would like to know if there is any performance issue if I enable it.
asked 2024-05-15T11:17:18.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 86%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar Kakarla (Quadrant Resource)
161
Reputation points
answered 2024-05-28T16:05:52.12+00:00
GeethaThatipatri-MSFT
27,977
Reputation points Microsoft Employee
2 answers
Can't enable private link with my newly created read replica server
Hi! I have a postgres SQL flexible server that is created in March 2023, I am not able to enable the private link because the server is created too long ago. I just created read replica server, but it has the same issue that I can't find private link…
asked 2024-05-17T23:17:19.1033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 64%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Ecccoyao
0
Reputation points
commented 2024-05-28T16:03:10.7966667+00:00
GeethaThatipatri-MSFT
27,977
Reputation points Microsoft Employee
2 answers
Azure PostgreSQL Flexible Server - Creating Database in pgAdmin tool
Hi, I am using Azure Database for PostgreSQL Flexible Servers, I cannot create database in pgAdmin due to missing privileges for pg_default tablespace. I cannot find that in documentation, could you confirm that creating databases are possible only in…
asked 2024-05-28T12:25:39.03+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 61%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKI%3C/text%3E%3C/svg%3E)
Karol IL
0
Reputation points
commented 2024-05-28T15:47:24.7533333+00:00
GeethaThatipatri-MSFT
27,977
Reputation points Microsoft Employee
1 answer
After Postgresql flexible migration from 14 to 16 admin user can't ALTER other role anymore
Since migrating my flexible server to postgresql version 16 my admin user can't modify roles anymore. With version 16 it's mandatory to have WITH ADMIN OPTION on roles to be able to alter them. My problem is that it wasn't the case on version 14 and my…
asked 2024-05-21T09:38:21.5333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 44%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Davi, Thomas
0
Reputation points
commented 2024-05-28T15:44:56.8166667+00:00
GeethaThatipatri-MSFT
27,977
Reputation points Microsoft Employee
2 answers
Flexible PostgreSQL server not responsive for unknown reason
Our web server suddenly started to fail to connect to our PostgreSQL flexible server, and the portal is stuck with the message 'The server is currently in 'restarting' state. Please wait for the operation to complete. You can refresh to check status.…
asked 2024-05-28T13:37:10.3866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 38%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
paxbun
0
Reputation points
answered 2024-05-28T15:28:03.2366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
8,751
Reputation points Microsoft Employee
2 answers
Azure data factory
Dear Team, I need to copy a data from a single table to multiple tables with mapping of columns in azure data factory by connecting with a PostgreSQL server. only one source table and I need to send that source data to the multiple sink tables by…
asked 2024-05-28T07:10:35.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 17%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sai Varma Eswararaju
0
Reputation points
answered 2024-05-28T09:24:26.49+00:00
AnnuKumari-MSFT
31,726
Reputation points Microsoft Employee
1 answer
Scheduled Backup doe not stop
Hello, i have a running Backup Job, that does not stop. It's running for over 24h now. I tried to stop it via GUI, which is not possible; also via Powershell / CLI which also failed. The GUI has no "Stop" button. The Powershell / CLI claims…
asked 2024-05-24T05:34:58.8566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 14.000000000000002%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Andreas Frisch
0
Reputation points
commented 2024-05-27T11:22:47.89+00:00
SadiqhAhmed-MSFT
39,236
Reputation points Microsoft Employee
4 answers
create sp to populate table from one db to another
Hi, how to create Store procedure to populate data from one database table to another database table and do we need to refresh or it will auto sync
asked 2024-05-21T02:56:37.6+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
205
Reputation points
answered 2024-05-24T06:02:16.3066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
13,996
Reputation points Microsoft Employee
1 answer
Azure PostgreSQL flexible Server Database Managed Identity connection
Hello, -We have created Azure postgres Flexible server with Microsoft Entra Authentication only deployment as Paas in Azure subscription. -We have added Azure Service Principal into Database admin user via Azure portal. We have created Azure VM and…
asked 2024-05-19T12:23:47.7566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 46%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Maruthuvel Ramachandran
5
Reputation points
answered 2024-05-24T05:23:48.54+00:00
ShaktiSingh-MSFT
13,996
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How can I manage the Virtual Network of an Azure PostgresSQL Flexible server after changing the DB's subscription?
I'm trying to move my cloud resources into a new Subscription. I was able to successfully move an Azure Database for PostgresSQL to a new subscription, however the attached virtual network cannot be changed. Per MSFT documentation, the attached virtual…
asked 2024-05-20T17:40:53.9533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Steve Christy
20
Reputation points
commented 2024-05-23T17:39:49.4766667+00:00
Oury Ba-MSFT
16,891
Reputation points Microsoft Employee
0 answers
How to Handle Point-in-Time Restore with Azure PostgreSQL and Terraform?
Hello, I'm using an Azure PostgreSQL database and need to perform a point-in-time restore (PITR) as part of a disaster recovery drill. I can successfully restore the database to a new server and update my application to point to this new server. However,…
asked 2024-05-22T12:49:03.72+00:00
Kamal Rathnayake
26
Reputation points MVP
commented 2024-05-23T13:03:43.9566667+00:00
Kamal Rathnayake
26
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
Why are Reservations not available for Ddsv5 instances on Azure PostgreSQL Flexible Server?
I'm calculating the cost of Azure PostgreSQL Flexible Server which uses Ddsv5 instance and notice that Reservations for this series and Dadsv5 instances are not available. Is there an explanation for this? Reservations are available for the older Ddsv4…
asked 2023-08-11T08:12:39.71+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 5%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Pitawat
336
Reputation points
commented 2024-05-22T20:13:14.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 73%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nygård Ronny
0
Reputation points
1 answer
Need to know ETA of reservations support for V5 instance series of Azure Database for PostgreSQL flexible server.
We need to know ETA of reservations support for V5 instance series of Azure Database for PostgreSQL flexible server, as we're thinking to upgrading all of our servers to V5 along with taking benefit of reservations for it.
asked 2023-10-02T13:46:13.6666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 99%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nayan Chhabhaiya
5
Reputation points
commented 2024-05-22T20:12:12.2333333+00:00
Nygård Ronny
0
Reputation points
1 answer
Failedto load PostgreSQL Flexible serverdatabases
Hi everyone Maybe who knows what is going on?
asked 2024-05-06T10:26:10.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Alexander Lapin
60
Reputation points
commented 2024-05-22T09:46:03.12+00:00
Alexander Lapin
60
Reputation points
1 answer
AZURE DATA FACTORY STORED PROCEDURE WITH POSTGRESQL SERVER
Dear Microsoft Support, I have created a stored procedure in a PostgreSQL server and established a linked service for that server in Azure Data Factory (ADF). My goal is to execute this stored procedure within a pipeline in ADF. However, when I attempt…
asked 2024-05-21T05:42:27.17+00:00
Sai Varma Eswararaju
0
Reputation points
commented 2024-05-22T05:06:12.4833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
10,880
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Do you know how to install the 'ODBC Driver 17 for PostgreSQL' on a Azure Databricks cluster?
I am attempting to run postgreSQL stored procedures , through Azure Databricks notebook. We have stored procedure written in Azure Database for PostgreSQL and we want to run postgreSQL stored procedures through Azure Databricks Notebook (using…
asked 2024-04-30T11:06:56.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 57.99999999999999%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anuj, Singh (Cognizant)
50
Reputation points
commented 2024-05-22T04:46:59.1066667+00:00
Anuj, Singh (Cognizant)
50
Reputation points
0 answers
How to unstack these data?
I was given these data below, and asked the following question. How would I go about it? B) From the below table, analyze, interpret and show the performance and trend within 3 years using the following secondary data of Women and girl traders’ annual…
asked 2024-05-21T08:39:22.59+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 39%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIG%3C/text%3E%3C/svg%3E)
Ignace Girukubonye
0
Reputation points
commented 2024-05-22T01:20:54.12+00:00
CosmogHong-MSFT
23,946
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure Synapse Analytics | Pipeline | Linked Service to "Azure Database for PostgreSQL" not available in 'Stored Procedure'
Hi everyone, I am trying to create a simple pipeline in Azure Synapse Analytics which should write some files' metadata fields into a Database. To do so, I first created a linked service to a postresql database instance hosted on Azure: I am now trying…
asked 2024-05-21T10:06:49.0933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 21%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Lorenzo Perino
20
Reputation points
accepted 2024-05-21T18:43:34.6533333+00:00
Lorenzo Perino
20
Reputation points
0 answers
Azure Database for PostgreSQL flexible server stuck in restart state
Hi, our Azure Database for PostgreSQL flexible server is stuck in restarting state. We noticed to late that storage is utilized 100% and now we can’t increase the instance or do any modifications. We can't even delete it, it just states that it is in…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 24%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
3 answers
pgaadauth_create_principal does not exist in my flexible postgresql instance
I am trying to create users that I will later use to log in from my kubernetes service. I have set up 2 admins for this database 1. being a user group on which I am added and the other being a service principal. I tried to use the create_principal…
asked 2024-04-13T15:44:47.7833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 54%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Armando Cordova
5
Reputation points
answered 2024-05-21T11:18:27.05+00:00
GeethaThatipatri-MSFT
27,977
Reputation points Microsoft Employee